Import Third Party Payment Batch
After you have completed the setup, you may begin to import and process batches of third party payments. To create a third party payment batch using the import process, follow the steps below. Use the import process to incorporate and reconcile payments in New World ERP that were generated in another system.
Once the import is complete, you can use the manual entry process to edit the batch and payment information. See Add or Edit a Third Party Payment Batch for more information.
- Go to Financial Management > Payment Processing > Third Party Payment Batches.
- On the Third Party Payment Batch List page, click Import. The Third Party Payment Batch-Import Batch page opens. The Batch Type (Import) displays the type of third party payment batch.
- In Responsible Department, select the department responsible for this payment batch.
- Select the Bank Account associated to the payment reconciliation batch. Users must be granted access to the account in User-Based Security.
- Select the Batch Date used for the payment batch.
- Select the External Source of the batch file, if needed. These values are defined in Validation Set 362. Press CTRL and click the field to open the Validation Set Values List dialog box where you can add or edit a validation set.
- Select the Create Journal check box if you want the payment batch to create a journal when the batch is posted. If selected, the Journal Information section displays.
Click here to see the selection criteria to define for the journal:
- In G/L Date, type or select the general ledger date of the journal to be applied to payment transactions as they are entered.
- In Fiscal Year, select the fiscal year of the journal generated by the payment batch.
- In Description, type the description of the batch; also, the default description of the journal entries created by the payment batch process.
- In Source, type the default source of the journal entries created by the payment batch process.
- In Reference, select the journal reference given to the batch. These values are defined by your organization in Validation Set 356, Journal Reference.
Batch Defaults
To alleviate the task of entering payment information for each payment in the batch, you can enter default batch information that applies to all payments. The defaults can be overridden for individual transactions.
- In Payment Type, select the default payment type for any payments entered in the batch.
- In Payment Date, select the default payment date for any payments entered in the batch.
- In Payment Description, type the default payment description for any payment entered in the batch.
- In Debit G/L Account, select the default general ledger account to debit for payments entered in the batch. Depending on the G/L account entered, you may be prompted to specify project information for the transactions.
- In Credit G/L Account, select the default general ledger account to credit for payments entered in the batch. Depending on the G/L account entered, you may be prompted to specify project information for the transactions.
- Click Next to go to Page 2 of the import process.
- Enter the appropriate Import Definition information. See Import Setup for more information on defining the import type Payment Import for the third party payment import process.
- Click Next to go to Page 3.
- On Page 3, select a check box next to the appropriate Processing Options, as needed. Notice the Validation Warning and Error Messages that display at the bottom of the page. Click a plus sign (+) next to the Error or Warning to expand the message and view detailed information.
- Click Next to complete the import process and generate Edit and Audit Listings if selected in Processing Options. Page 4 displays the Import Confirmation information.